Overview
Brought to you by YData
Dataset statistics
| Number of variables | 17 |
|---|---|
| Number of observations | 10127 |
| Missing cells | 44 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 4.7 MiB |
| Average record size in memory | 482.3 B |
Variable types
| Numeric | 8 |
|---|---|
| Categorical | 6 |
| Text | 3 |
isFlaggedFraud has constant value "0" | Constant |
Unnamed: 0 is highly overall correlated with step | High correlation |
amount is highly overall correlated with newbalanceDest and 1 other fields | High correlation |
newbalanceDest is highly overall correlated with amount and 1 other fields | High correlation |
newbalanceOrig is highly overall correlated with oldbalanceOrg | High correlation |
oldbalanceDest is highly overall correlated with amount and 1 other fields | High correlation |
oldbalanceOrg is highly overall correlated with newbalanceOrig | High correlation |
step is highly overall correlated with Unnamed: 0 | High correlation |
isFraud is highly imbalanced (94.2%) | Imbalance |
Unnamed: 0 is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
oldbalanceOrg has 2451 (24.2%) zeros | Zeros |
newbalanceOrig has 4123 (40.7%) zeros | Zeros |
oldbalanceDest has 5760 (56.9%) zeros | Zeros |
newbalanceDest has 5908 (58.3%) zeros | Zeros |
Reproduction
| Analysis started | 2025-08-17 11:07:19.694364 |
|---|---|
| Analysis finished | 2025-08-17 11:07:34.784893 |
| Duration | 15.09 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
Unnamed: 0
Real number (ℝ)
High correlation Uniform Unique
| Distinct | 10127 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5063 |
| Minimum | 0 |
|---|---|
| Maximum | 10126 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 506.3 |
| Q1 | 2531.5 |
| median | 5063 |
| Q3 | 7594.5 |
| 95-th percentile | 9619.7 |
| Maximum | 10126 |
| Range | 10126 |
| Interquartile range (IQR) | 5063 |
Descriptive statistics
| Standard deviation | 2923.5574 |
|---|---|
| Coefficient of variation (CV) | 0.57743579 |
| Kurtosis | -1.2 |
| Mean | 5063 |
| Median Absolute Deviation (MAD) | 2532 |
| Skewness | 0 |
| Sum | 51273001 |
| Variance | 8547188 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 6754 | 1 | < 0.1% |
| 6747 | 1 | < 0.1% |
| 6748 | 1 | < 0.1% |
| 6749 | 1 | < 0.1% |
| 6750 | 1 | < 0.1% |
| 6751 | 1 | < 0.1% |
| 6752 | 1 | < 0.1% |
| 6753 | 1 | < 0.1% |
| 6755 | 1 | < 0.1% |
| Other values (10117) | 10117 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 10126 | 1 | |
| 10125 | 1 | |
| 10124 | 1 | |
| 10123 | 1 | |
| 10122 | 1 | |
| 10121 | 1 | |
| 10120 | 1 | |
| 10119 | 1 | |
| 10118 | 1 | |
| 10117 | 1 |
step
Real number (ℝ)
High correlation
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.2142787 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 5 |
| Q3 | 7 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 2.4841392 |
|---|---|
| Coefficient of variation (CV) | 0.58945775 |
| Kurtosis | -1.6769781 |
| Mean | 4.2142787 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.18107797 |
| Sum | 42678 |
| Variance | 6.1709476 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 7 | 2963 | |
| 1 | 2708 | |
| 6 | 1660 | |
| 2 | 1014 | 10.0% |
| 5 | 665 | 6.6% |
| 4 | 565 | 5.6% |
| 3 | 552 | 5.5% |
| Value | Count | Frequency (%) |
| 1 | 2708 | |
| 2 | 1014 | 10.0% |
| 3 | 552 | 5.5% |
| 4 | 565 | 5.6% |
| 5 | 665 | 6.6% |
| 6 | 1660 | |
| 7 | 2963 |
| Value | Count | Frequency (%) |
| 7 | 2963 | |
| 6 | 1660 | |
| 5 | 665 | 6.6% |
| 4 | 565 | 5.6% |
| 3 | 552 | 5.5% |
| 2 | 1014 | 10.0% |
| 1 | 2708 |
type
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Memory size | 555.5 KiB |
| PAYMENT | |
|---|---|
| CASH_IN | |
| CASH_OUT | |
| TRANSFER | |
| DEBIT | 346 |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 7.1571668 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PAYMENT |
|---|---|
| 2nd row | PAYMENT |
| 3rd row | TRANSFER |
| 4th row | CASH_OUT |
| 5th row | PAYMENT |
Common Values
| Value | Count | Frequency (%) |
| PAYMENT | 5541 | |
| CASH_IN | 1953 | 19.3% |
| CASH_OUT | 1337 | 13.2% |
| TRANSFER | 946 | 9.3% |
| DEBIT | 346 | 3.4% |
| (Missing) | 4 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| payment | 5541 | |
| cash_in | 1953 | 19.3% |
| cash_out | 1337 | 13.2% |
| transfer | 946 | 9.3% |
| debit | 346 | 3.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 9777 | |
| N | 8440 | |
| T | 8170 | |
| E | 6833 | |
| P | 5541 | |
| Y | 5541 | |
| M | 5541 | |
| S | 4236 | 5.8% |
| _ | 3290 | 4.5% |
| H | 3290 | 4.5% |
| Other values (8) | 11793 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 69162 | |
| Connector Punctuation | 3290 | 4.5% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 9777 | |
| N | 8440 | |
| T | 8170 | |
| E | 6833 | |
| P | 5541 | |
| Y | 5541 | |
| M | 5541 | |
| S | 4236 | |
| H | 3290 | 4.8% |
| C | 3290 | 4.8% |
| Other values (7) | 8503 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 3290 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 69162 | |
| Common | 3290 | 4.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 9777 | |
| N | 8440 | |
| T | 8170 | |
| E | 6833 | |
| P | 5541 | |
| Y | 5541 | |
| M | 5541 | |
| S | 4236 | |
| H | 3290 | 4.8% |
| C | 3290 | 4.8% |
| Other values (7) | 8503 |
Common
| Value | Count | Frequency (%) |
| _ | 3290 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 72452 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 9777 | |
| N | 8440 | |
| T | 8170 | |
| E | 6833 | |
| P | 5541 | |
| Y | 5541 | |
| M | 5541 | |
| S | 4236 | 5.8% |
| _ | 3290 | 4.5% |
| H | 3290 | 4.5% |
| Other values (8) | 11793 |
branch
Text
| Distinct | 135 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 570.3 KiB |
Length
| Max length | 31 |
|---|---|
| Median length | 20 |
| Mean length | 8.6530068 |
| Min length | 4 |
Unique
| Unique | 15 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Indonesia |
|---|---|
| 2nd row | India |
| 3rd row | India |
| 4th row | Australia |
| 5th row | Australia |
| Value | Count | Frequency (%) |
| unidos | 1284 | 10.1% |
| estados | 1283 | 10.1% |
| francia | 735 | 5.8% |
| mexico | 670 | 5.3% |
| australia | 633 | 5.0% |
| alemania | 499 | 3.9% |
| china | 453 | 3.6% |
| brasil | 444 | 3.5% |
| india | 391 | 3.1% |
| reino | 370 | 2.9% |
| Other values (145) | 5976 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 13961 | |
| i | 9904 | 11.3% |
| n | 7070 | 8.1% |
| s | 6486 | 7.4% |
| o | 5810 | 6.6% |
| d | 4617 | 5.3% |
| r | 3710 | 4.2% |
| l | 3624 | 4.1% |
| e | 3588 | 4.1% |
| t | 2877 | 3.3% |
| Other values (42) | 25982 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 72298 | |
| Uppercase Letter | 12666 | 14.5% |
| Space Separator | 2611 | 3.0% |
| Open Punctuation | 27 | < 0.1% |
| Close Punctuation | 27 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 13961 | |
| i | 9904 | |
| n | 7070 | |
| s | 6486 | |
| o | 5810 | |
| d | 4617 | 6.4% |
| r | 3710 | 5.1% |
| l | 3624 | 5.0% |
| e | 3588 | 5.0% |
| t | 2877 | 4.0% |
| Other values (15) | 10651 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 1731 | |
| U | 1731 | |
| A | 1464 | |
| I | 1196 | |
| C | 941 | |
| F | 933 | |
| M | 813 | |
| R | 717 | 5.7% |
| B | 687 | 5.4% |
| S | 476 | 3.8% |
| Other values (14) | 1977 |
Space Separator
| Value | Count | Frequency (%) |
| 2611 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 27 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 27 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 84964 | |
| Common | 2665 | 3.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 13961 | |
| i | 9904 | |
| n | 7070 | 8.3% |
| s | 6486 | 7.6% |
| o | 5810 | 6.8% |
| d | 4617 | 5.4% |
| r | 3710 | 4.4% |
| l | 3624 | 4.3% |
| e | 3588 | 4.2% |
| t | 2877 | 3.4% |
| Other values (39) | 23317 |
Common
| Value | Count | Frequency (%) |
| 2611 | ||
| ( | 27 | 1.0% |
| ) | 27 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 87629 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 13961 | |
| i | 9904 | 11.3% |
| n | 7070 | 8.1% |
| s | 6486 | 7.4% |
| o | 5810 | 6.6% |
| d | 4617 | 5.3% |
| r | 3710 | 4.2% |
| l | 3624 | 4.1% |
| e | 3588 | 4.1% |
| t | 2877 | 3.3% |
| Other values (42) | 25982 |
amount
Real number (ℝ)
High correlation
| Distinct | 10079 |
|---|---|
| Distinct (%) | 99.5% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 104886.88 |
| Minimum | 2.39 |
|---|---|
| Maximum | 10000000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 2.39 |
|---|---|
| 5-th percentile | 831.902 |
| Q1 | 4397.38 |
| median | 12798.31 |
| Q3 | 114381.77 |
| 95-th percentile | 438359.09 |
| Maximum | 10000000 |
| Range | 9999997.6 |
| Interquartile range (IQR) | 109984.39 |
Descriptive statistics
| Standard deviation | 270636.89 |
|---|---|
| Coefficient of variation (CV) | 2.580274 |
| Kurtosis | 376.30214 |
| Mean | 104886.88 |
| Median Absolute Deviation (MAD) | 11223.14 |
| Skewness | 13.169771 |
| Sum | 1.0619796 × 109 |
| Variance | 7.3244326 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 25975.86 | 3 | < 0.1% |
| 354.75 | 2 | < 0.1% |
| 262434.54 | 2 | < 0.1% |
| 85354.69 | 2 | < 0.1% |
| 3643.48 | 2 | < 0.1% |
| 169941.73 | 2 | < 0.1% |
| 20128 | 2 | < 0.1% |
| 5146.88 | 2 | < 0.1% |
| 1937.5 | 2 | < 0.1% |
| 17246 | 2 | < 0.1% |
| Other values (10069) | 10104 |
| Value | Count | Frequency (%) |
| 2.39 | 1 | |
| 3.75 | 1 | |
| 4.36 | 1 | |
| 6.36 | 1 | |
| 6.42 | 1 | |
| 6.93 | 1 | |
| 8.73 | 1 | |
| 10.48 | 1 | |
| 13.54 | 1 | |
| 15.06 | 1 |
| Value | Count | Frequency (%) |
| 10000000 | 2 | |
| 3776389.09 | 1 | |
| 2943845.35 | 1 | |
| 2940764.72 | 1 | |
| 2930418.44 | 2 | |
| 2861134.92 | 1 | |
| 2837270.65 | 1 | |
| 2604219.11 | 1 | |
| 2576294.8 | 1 | |
| 2545478.01 | 1 |
nameOrig
Text
| Distinct | 10121 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 6 |
| Missing (%) | 0.1% |
| Memory size | 588.2 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.481672 |
| Min length | 6 |
Unique
| Unique | 10121 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | C1231006815 |
|---|---|
| 2nd row | C1666544295 |
| 3rd row | C1305486145 |
| 4th row | C840083671 |
| 5th row | C2048537720 |
| Value | Count | Frequency (%) |
| c1231006815 | 1 | < 0.1% |
| c1912850431 | 1 | < 0.1% |
| c207471778 | 1 | < 0.1% |
| c712410124 | 1 | < 0.1% |
| c1305486145 | 1 | < 0.1% |
| c840083671 | 1 | < 0.1% |
| c2048537720 | 1 | < 0.1% |
| c90045638 | 1 | < 0.1% |
| c154988899 | 1 | < 0.1% |
| c1265012928 | 1 | < 0.1% |
| Other values (10111) | 10111 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 13989 | |
| C | 10121 | |
| 2 | 9898 | |
| 0 | 9174 | |
| 6 | 9075 | |
| 8 | 9070 | |
| 7 | 9018 | |
| 9 | 8968 | |
| 5 | 8926 | |
| 4 | 8926 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 95964 | |
| Uppercase Letter | 10121 | 9.5% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 13989 | |
| 2 | 9898 | |
| 0 | 9174 | |
| 6 | 9075 | |
| 8 | 9070 | |
| 7 | 9018 | |
| 9 | 8968 | |
| 5 | 8926 | |
| 4 | 8926 | |
| 3 | 8920 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 10121 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 95964 | |
| Latin | 10121 | 9.5% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 13989 | |
| 2 | 9898 | |
| 0 | 9174 | |
| 6 | 9075 | |
| 8 | 9070 | |
| 7 | 9018 | |
| 9 | 8968 | |
| 5 | 8926 | |
| 4 | 8926 | |
| 3 | 8920 |
Latin
| Value | Count | Frequency (%) |
| C | 10121 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 106085 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 13989 | |
| C | 10121 | |
| 2 | 9898 | |
| 0 | 9174 | |
| 6 | 9075 | |
| 8 | 9070 | |
| 7 | 9018 | |
| 9 | 8968 | |
| 5 | 8926 | |
| 4 | 8926 |
oldbalanceOrg
Real number (ℝ)
High correlation Zeros
| Distinct | 7328 |
|---|---|
| Distinct (%) | 72.4% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 883696.53 |
| Minimum | 0 |
|---|---|
| Maximum | 12900000 |
| Zeros | 2451 |
| Zeros (%) | 24.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 129 |
| median | 21363 |
| Q3 | 172432 |
| 95-th percentile | 6372330.9 |
| Maximum | 12900000 |
| Range | 12900000 |
| Interquartile range (IQR) | 172303 |
Descriptive statistics
| Standard deviation | 2124553.9 |
|---|---|
| Coefficient of variation (CV) | 2.4041668 |
| Kurtosis | 7.2910661 |
| Mean | 883696.53 |
| Median Absolute Deviation (MAD) | 21363 |
| Skewness | 2.7797342 |
| Sum | 8.9474274 × 109 |
| Variance | 4.5137293 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 2451 | 24.2% |
| 10500000 | 7 | 0.1% |
| 10300000 | 6 | 0.1% |
| 322 | 5 | < 0.1% |
| 337 | 5 | < 0.1% |
| 10700000 | 5 | < 0.1% |
| 122 | 5 | < 0.1% |
| 189 | 4 | < 0.1% |
| 10000000 | 4 | < 0.1% |
| 198 | 4 | < 0.1% |
| Other values (7318) | 7629 |
| Value | Count | Frequency (%) |
| 0 | 2451 | |
| 1 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4.58 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| 14.09 | 1 | < 0.1% |
| 17 | 1 | < 0.1% |
| 21 | 1 | < 0.1% |
| 24 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 12900000 | 2 | |
| 12800000 | 1 | < 0.1% |
| 12700000 | 1 | < 0.1% |
| 12600000 | 1 | < 0.1% |
| 12500000 | 2 | |
| 12300000 | 2 | |
| 12200000 | 3 | |
| 12100000 | 2 | |
| 11900000 | 2 | |
| 11800000 | 2 |
newbalanceOrig
Real number (ℝ)
High correlation Zeros
| Distinct | 5937 |
|---|---|
| Distinct (%) | 58.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 904470.34 |
| Minimum | 0 |
|---|---|
| Maximum | 13000000 |
| Zeros | 4123 |
| Zeros (%) | 40.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 10212.24 |
| Q3 | 170724.01 |
| 95-th percentile | 6498321.5 |
| Maximum | 13000000 |
| Range | 13000000 |
| Interquartile range (IQR) | 170724.01 |
Descriptive statistics
| Standard deviation | 2169946 |
|---|---|
| Coefficient of variation (CV) | 2.3991345 |
| Kurtosis | 7.0308777 |
| Mean | 904470.34 |
| Median Absolute Deviation (MAD) | 10212.24 |
| Skewness | 2.7386293 |
| Sum | 9.1595711 × 109 |
| Variance | 4.7086658 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 4123 | |
| 10500000 | 7 | 0.1% |
| 10700000 | 6 | 0.1% |
| 10300000 | 6 | 0.1% |
| 10200000 | 5 | < 0.1% |
| 11100000 | 4 | < 0.1% |
| 11200000 | 3 | < 0.1% |
| 10100000 | 3 | < 0.1% |
| 10000000 | 3 | < 0.1% |
| 12500000 | 3 | < 0.1% |
| Other values (5927) | 5964 |
| Value | Count | Frequency (%) |
| 0 | 4123 | |
| 4.58 | 1 | < 0.1% |
| 5.83 | 1 | < 0.1% |
| 14.09 | 1 | < 0.1% |
| 14.33 | 1 | < 0.1% |
| 21.47 | 1 | < 0.1% |
| 22.87 | 1 | < 0.1% |
| 28.72 | 1 | < 0.1% |
| 41.05 | 1 | < 0.1% |
| 53.15 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 13000000 | 1 | < 0.1% |
| 12900000 | 1 | < 0.1% |
| 12800000 | 1 | < 0.1% |
| 12700000 | 2 | |
| 12600000 | 1 | < 0.1% |
| 12500000 | 3 | |
| 12400000 | 1 | < 0.1% |
| 12300000 | 2 | |
| 12200000 | 3 | |
| 12100000 | 2 |
nameDest
Text
| Distinct | 6495 |
|---|---|
| Distinct (%) | 64.2% |
| Missing | 6 |
| Missing (%) | 0.1% |
| Memory size | 588.2 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.475151 |
| Min length | 7 |
Unique
| Unique | 5905 ? |
|---|---|
| Unique (%) | 58.3% |
Sample
| 1st row | M1979787155 |
|---|---|
| 2nd row | M2044282225 |
| 3rd row | C553264065 |
| 4th row | C38997010 |
| 5th row | M1230701703 |
| Value | Count | Frequency (%) |
| c985934102 | 62 | 0.6% |
| c1590550415 | 51 | 0.5% |
| c1286084959 | 50 | 0.5% |
| c1899073220 | 44 | 0.4% |
| c977993101 | 44 | 0.4% |
| c1782113663 | 43 | 0.4% |
| c451111351 | 43 | 0.4% |
| c2083562754 | 41 | 0.4% |
| c1360767589 | 40 | 0.4% |
| c1816757085 | 40 | 0.4% |
| Other values (6485) | 9663 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 14227 | |
| 5 | 9525 | |
| 2 | 9402 | |
| 8 | 9223 | |
| 0 | 9165 | |
| 7 | 9095 | |
| 3 | 9043 | |
| 4 | 8770 | |
| 9 | 8758 | |
| 6 | 8690 | |
| Other values (2) | 10121 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 95898 | |
| Uppercase Letter | 10121 | 9.5% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 14227 | |
| 5 | 9525 | |
| 2 | 9402 | |
| 8 | 9223 | |
| 0 | 9165 | |
| 7 | 9095 | |
| 3 | 9043 | |
| 4 | 8770 | |
| 9 | 8758 | |
| 6 | 8690 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 5540 | |
| C | 4581 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 95898 | |
| Latin | 10121 | 9.5% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 14227 | |
| 5 | 9525 | |
| 2 | 9402 | |
| 8 | 9223 | |
| 0 | 9165 | |
| 7 | 9095 | |
| 3 | 9043 | |
| 4 | 8770 | |
| 9 | 8758 | |
| 6 | 8690 |
Latin
| Value | Count | Frequency (%) |
| M | 5540 | |
| C | 4581 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 106019 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 14227 | |
| 5 | 9525 | |
| 2 | 9402 | |
| 8 | 9223 | |
| 0 | 9165 | |
| 7 | 9095 | |
| 3 | 9043 | |
| 4 | 8770 | |
| 9 | 8758 | |
| 6 | 8690 | |
| Other values (2) | 10121 |
oldbalanceDest
Real number (ℝ)
High correlation Zeros
| Distinct | 4161 |
|---|---|
| Distinct (%) | 41.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 933539.3 |
| Minimum | 0 |
|---|---|
| Maximum | 19500000 |
| Zeros | 5760 |
| Zeros (%) | 56.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 281934.51 |
| 95-th percentile | 6588780.3 |
| Maximum | 19500000 |
| Range | 19500000 |
| Interquartile range (IQR) | 281934.51 |
Descriptive statistics
| Standard deviation | 2677976.1 |
|---|---|
| Coefficient of variation (CV) | 2.8686271 |
| Kurtosis | 16.423177 |
| Mean | 933539.3 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.9098289 |
| Sum | 9.4530189 × 109 |
| Variance | 7.1715559 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 5760 | |
| 10900000 | 12 | 0.1% |
| 10700000 | 9 | 0.1% |
| 10300000 | 9 | 0.1% |
| 13100000 | 8 | 0.1% |
| 10100000 | 7 | 0.1% |
| 10400000 | 7 | 0.1% |
| 10800000 | 7 | 0.1% |
| 10200000 | 7 | 0.1% |
| 13300000 | 7 | 0.1% |
| Other values (4151) | 4293 |
| Value | Count | Frequency (%) |
| 0 | 5760 | |
| 7 | 1 | < 0.1% |
| 23 | 1 | < 0.1% |
| 55 | 1 | < 0.1% |
| 65 | 1 | < 0.1% |
| 102 | 1 | < 0.1% |
| 122 | 1 | < 0.1% |
| 137 | 1 | < 0.1% |
| 144 | 1 | < 0.1% |
| 150 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 19500000 | 1 | < 0.1% |
| 19400000 | 2 | |
| 19300000 | 2 | |
| 19200000 | 1 | < 0.1% |
| 19100000 | 2 | |
| 18700000 | 3 | |
| 18500000 | 1 | < 0.1% |
| 18400000 | 1 | < 0.1% |
| 18300000 | 2 | |
| 18200000 | 2 |
newbalanceDest
Real number (ℝ)
High correlation Zeros
| Distinct | 1509 |
|---|---|
| Distinct (%) | 14.9% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1109314.9 |
| Minimum | 0 |
|---|---|
| Maximum | 22600000 |
| Zeros | 5908 |
| Zeros (%) | 58.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 252392.49 |
| 95-th percentile | 7526564.9 |
| Maximum | 22600000 |
| Range | 22600000 |
| Interquartile range (IQR) | 252392.49 |
Descriptive statistics
| Standard deviation | 3048644.5 |
|---|---|
| Coefficient of variation (CV) | 2.7482229 |
| Kurtosis | 13.632469 |
| Mean | 1109314.9 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.600117 |
| Sum | 1.1231813 × 1010 |
| Variance | 9.2942332 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 5908 | |
| 971418.91 | 32 | 0.3% |
| 19200000 | 29 | 0.3% |
| 10700000 | 25 | 0.2% |
| 1254956.07 | 25 | 0.2% |
| 12500000 | 23 | 0.2% |
| 10200000 | 22 | 0.2% |
| 1412484.09 | 22 | 0.2% |
| 1178808.14 | 21 | 0.2% |
| 1517262.16 | 19 | 0.2% |
| Other values (1499) | 3999 |
| Value | Count | Frequency (%) |
| 0 | 5908 | |
| 96.88 | 3 | < 0.1% |
| 206.12 | 1 | < 0.1% |
| 324.52 | 1 | < 0.1% |
| 371.65 | 9 | 0.1% |
| 658.85 | 1 | < 0.1% |
| 667.54 | 1 | < 0.1% |
| 787.49 | 1 | < 0.1% |
| 817.21 | 4 | < 0.1% |
| 823.49 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 22600000 | 1 | < 0.1% |
| 19200000 | 29 | |
| 18700000 | 4 | < 0.1% |
| 18400000 | 1 | < 0.1% |
| 18300000 | 1 | < 0.1% |
| 18100000 | 13 | |
| 18000000 | 5 | < 0.1% |
| 17800000 | 17 | |
| 17400000 | 1 | < 0.1% |
| 17300000 | 8 | 0.1% |
unusuallogin
Real number (ℝ)
| Distinct | 21 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.513183 |
| Minimum | 0 |
|---|---|
| Maximum | 20 |
| Zeros | 4 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 6 |
| median | 10 |
| Q3 | 16 |
| 95-th percentile | 20 |
| Maximum | 20 |
| Range | 20 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 5.8092327 |
|---|---|
| Coefficient of variation (CV) | 0.55256652 |
| Kurtosis | -1.2098878 |
| Mean | 10.513183 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.0069519359 |
| Sum | 106467 |
| Variance | 33.747184 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=21)
| Value | Count | Frequency (%) |
| 18 | 550 | 5.4% |
| 20 | 539 | 5.3% |
| 2 | 526 | 5.2% |
| 8 | 522 | 5.2% |
| 19 | 522 | 5.2% |
| 11 | 521 | 5.1% |
| 12 | 515 | 5.1% |
| 6 | 514 | 5.1% |
| 9 | 514 | 5.1% |
| 1 | 511 | 5.0% |
| Other values (11) | 4893 |
| Value | Count | Frequency (%) |
| 0 | 4 | < 0.1% |
| 1 | 511 | |
| 2 | 526 | |
| 3 | 508 | |
| 4 | 493 | |
| 5 | 484 | |
| 6 | 514 | |
| 7 | 491 | |
| 8 | 522 | |
| 9 | 514 |
| Value | Count | Frequency (%) |
| 20 | 539 | |
| 19 | 522 | |
| 18 | 550 | |
| 17 | 477 | |
| 16 | 502 | |
| 15 | 465 | |
| 14 | 467 | |
| 13 | 494 | |
| 12 | 515 | |
| 11 | 521 |
isFlaggedFraud
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 494.6 KiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 10127 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 10127 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 10127 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 10127 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 10127 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 10127 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 10127 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10127 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 10127 |
Acct type
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 10 |
| Missing (%) | 0.1% |
| Memory size | 553.9 KiB |
| Savings | |
|---|---|
| Current |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Current |
|---|---|
| 2nd row | Savings |
| 3rd row | Current |
| 4th row | Current |
| 5th row | Current |
Common Values
| Value | Count | Frequency (%) |
| Savings | 6987 | |
| Current | 3130 | |
| (Missing) | 10 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| savings | 6987 | |
| current | 3130 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 10117 | |
| S | 6987 | |
| a | 6987 | |
| v | 6987 | |
| i | 6987 | |
| g | 6987 | |
| s | 6987 | |
| r | 6260 | |
| C | 3130 | 4.4% |
| u | 3130 | 4.4% |
| Other values (2) | 6260 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 60702 | |
| Uppercase Letter | 10117 | 14.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 10117 | |
| a | 6987 | |
| v | 6987 | |
| i | 6987 | |
| g | 6987 | |
| s | 6987 | |
| r | 6260 | |
| u | 3130 | 5.2% |
| e | 3130 | 5.2% |
| t | 3130 | 5.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 6987 | |
| C | 3130 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 70819 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 10117 | |
| S | 6987 | |
| a | 6987 | |
| v | 6987 | |
| i | 6987 | |
| g | 6987 | |
| s | 6987 | |
| r | 6260 | |
| C | 3130 | 4.4% |
| u | 3130 | 4.4% |
| Other values (2) | 6260 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 70819 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 10117 | |
| S | 6987 | |
| a | 6987 | |
| v | 6987 | |
| i | 6987 | |
| g | 6987 | |
| s | 6987 | |
| r | 6260 | |
| C | 3130 | 4.4% |
| u | 3130 | 4.4% |
| Other values (2) | 6260 |
Date of transaction
Categorical
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 7 |
| Missing (%) | 0.1% |
| Memory size | 568.8 KiB |
| 6/1/2018 | |
|---|---|
| 5/1/2018 | |
| 7/1/2018 | |
| 8/1/2018 | |
| 10/1/2018 | |
| Other values (9) |
Length
| Max length | 9 |
|---|---|
| Median length | 8.5 |
| Mean length | 8.5 |
| Min length | 8 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 3/1/2018 |
|---|---|
| 2nd row | 5/1/2018 |
| 3rd row | 7/1/2018 |
| 4th row | 6/1/2018 |
| 5th row | 6/1/2018 |
Common Values
| Value | Count | Frequency (%) |
| 6/1/2018 | 1446 | |
| 5/1/2018 | 724 | 7.1% |
| 7/1/2018 | 723 | 7.1% |
| 8/1/2018 | 723 | 7.1% |
| 10/1/2018 | 723 | 7.1% |
| 11/1/2018 | 723 | 7.1% |
| 12/1/2018 | 723 | 7.1% |
| 13/1/2018 | 723 | 7.1% |
| 19/1/2018 | 723 | 7.1% |
| 25/1/2018 | 723 | 7.1% |
| Other values (4) | 2166 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 6/1/2018 | 1446 | |
| 5/1/2018 | 724 | 7.2% |
| 7/1/2018 | 723 | 7.1% |
| 8/1/2018 | 723 | 7.1% |
| 10/1/2018 | 723 | 7.1% |
| 11/1/2018 | 723 | 7.1% |
| 12/1/2018 | 723 | 7.1% |
| 13/1/2018 | 723 | 7.1% |
| 19/1/2018 | 723 | 7.1% |
| 25/1/2018 | 723 | 7.1% |
| Other values (4) | 2166 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 25300 | |
| / | 20240 | |
| 2 | 11567 | |
| 0 | 10843 | |
| 8 | 10843 | |
| 6 | 2168 | 2.5% |
| 5 | 1447 | 1.7% |
| 3 | 1445 | 1.7% |
| 9 | 1444 | 1.7% |
| 7 | 723 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 65780 | |
| Other Punctuation | 20240 | 23.5% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 25300 | |
| 2 | 11567 | |
| 0 | 10843 | |
| 8 | 10843 | |
| 6 | 2168 | 3.3% |
| 5 | 1447 | 2.2% |
| 3 | 1445 | 2.2% |
| 9 | 1444 | 2.2% |
| 7 | 723 | 1.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 20240 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 86020 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 25300 | |
| / | 20240 | |
| 2 | 11567 | |
| 0 | 10843 | |
| 8 | 10843 | |
| 6 | 2168 | 2.5% |
| 5 | 1447 | 1.7% |
| 3 | 1445 | 1.7% |
| 9 | 1444 | 1.7% |
| 7 | 723 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 86020 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 25300 | |
| / | 20240 | |
| 2 | 11567 | |
| 0 | 10843 | |
| 8 | 10843 | |
| 6 | 2168 | 2.5% |
| 5 | 1447 | 1.7% |
| 3 | 1445 | 1.7% |
| 9 | 1444 | 1.7% |
| 7 | 723 | 0.8% |
Time of day
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 554.6 KiB |
| Afternoon | |
|---|---|
| Night | |
| Morning |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.0657778 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Morning |
|---|---|
| 2nd row | Morning |
| 3rd row | Morning |
| 4th row | Afternoon |
| 5th row | Morning |
Common Values
| Value | Count | Frequency (%) |
| Afternoon | 3627 | |
| Night | 3294 | |
| Morning | 3204 | |
| (Missing) | 2 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| afternoon | 3627 | |
| night | 3294 | |
| morning | 3204 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 13662 | |
| o | 10458 | |
| t | 6921 | |
| r | 6831 | |
| i | 6498 | |
| g | 6498 | |
| A | 3627 | 5.1% |
| f | 3627 | 5.1% |
| e | 3627 | 5.1% |
| N | 3294 | 4.6% |
| Other values (2) | 6498 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 61416 | |
| Uppercase Letter | 10125 | 14.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 13662 | |
| o | 10458 | |
| t | 6921 | |
| r | 6831 | |
| i | 6498 | |
| g | 6498 | |
| f | 3627 | 5.9% |
| e | 3627 | 5.9% |
| h | 3294 | 5.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 3627 | |
| N | 3294 | |
| M | 3204 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 71541 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 13662 | |
| o | 10458 | |
| t | 6921 | |
| r | 6831 | |
| i | 6498 | |
| g | 6498 | |
| A | 3627 | 5.1% |
| f | 3627 | 5.1% |
| e | 3627 | 5.1% |
| N | 3294 | 4.6% |
| Other values (2) | 6498 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 71541 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 13662 | |
| o | 10458 | |
| t | 6921 | |
| r | 6831 | |
| i | 6498 | |
| g | 6498 | |
| A | 3627 | 5.1% |
| f | 3627 | 5.1% |
| e | 3627 | 5.1% |
| N | 3294 | 4.6% |
| Other values (2) | 6498 |
isFraud
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 514.4 KiB |
| 0.0 | |
|---|---|
| 1.0 | 68 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 10057 | |
| 1.0 | 68 | 0.7% |
| (Missing) | 2 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 10057 | |
| 1.0 | 68 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 20182 | |
| . | 10125 | |
| 1 | 68 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 20250 | |
| Other Punctuation | 10125 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 20182 | |
| 1 | 68 | 0.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 10125 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 30375 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 20182 | |
| . | 10125 | |
| 1 | 68 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 30375 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 20182 | |
| . | 10125 | |
| 1 | 68 | 0.2% |
Interactions
Correlations
| Acct type | Date of transaction | Time of day | Unnamed: 0 | amount | isFraud | newbalanceDest | newbalanceOrig | oldbalanceDest | oldbalanceOrg | step | type | unusuallogin | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Acct type | 1.000 | 0.309 | 0.011 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.014 |
| Date of transaction | 0.309 | 1.000 | 0.000 | 0.000 | 0.000 | 0.015 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| Time of day | 0.011 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.015 | 0.000 | 0.016 | 0.000 | 0.012 | 0.014 |
| Unnamed: 0 | 0.000 | 0.000 | 0.000 | 1.000 | 0.059 | 0.054 | -0.005 | -0.074 | -0.040 | -0.053 | 0.975 | 0.125 | -0.004 |
| amount | 0.000 | 0.000 | 0.000 | 0.059 | 1.000 | 0.180 | 0.736 | 0.016 | 0.739 | 0.107 | 0.068 | 0.170 | -0.014 |
| isFraud | 0.000 | 0.015 | 0.000 | 0.054 | 0.180 | 1.000 | 0.000 | 0.016 | 0.000 | 0.025 | 0.056 | 0.153 | 0.108 |
| newbalanceDest | 0.000 | 0.000 | 0.000 | -0.005 | 0.736 | 0.000 | 1.000 | 0.091 | 0.928 | 0.135 | 0.000 | 0.215 | -0.010 |
| newbalanceOrig | 0.000 | 0.000 | 0.015 | -0.074 | 0.016 | 0.016 | 0.091 | 1.000 | 0.180 | 0.915 | -0.078 | 0.431 | 0.020 |
| oldbalanceDest | 0.000 | 0.000 | 0.000 | -0.040 | 0.739 | 0.000 | 0.928 | 0.180 | 1.000 | 0.183 | -0.032 | 0.207 | -0.005 |
| oldbalanceOrg | 0.000 | 0.000 | 0.016 | -0.053 | 0.107 | 0.025 | 0.135 | 0.915 | 0.183 | 1.000 | -0.060 | 0.423 | 0.019 |
| step | 0.000 | 0.000 | 0.000 | 0.975 | 0.068 | 0.056 | 0.000 | -0.078 | -0.032 | -0.060 | 1.000 | 0.077 | -0.008 |
| type | 0.000 | 0.000 | 0.012 | 0.125 | 0.170 | 0.153 | 0.215 | 0.431 | 0.207 | 0.423 | 0.077 | 1.000 | 0.019 |
| unusuallogin | 0.014 | 0.000 | 0.014 | -0.004 | -0.014 | 0.108 | -0.010 | 0.020 | -0.005 | 0.019 | -0.008 | 0.019 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| Unnamed: 0 | step | type | branch | amount | nameOrig | oldbalanceOrg | newbalanceOrig | nameDest | oldbalanceDest | newbalanceDest | unusuallogin | isFlaggedFraud | Acct type | Date of transaction | Time of day | isFraud | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 1 | PAYMENT | Indonesia | 9839.64 | C1231006815 | 170136.00 | 160296.36 | M1979787155 | 0.0 | 0.00 | 9 | 0 | Current | 3/1/2018 | Morning | 0.0 |
| 1 | 1 | 1 | PAYMENT | India | 1864.28 | C1666544295 | 21249.00 | 19384.72 | M2044282225 | 0.0 | 0.00 | 10 | 0 | Savings | 5/1/2018 | Morning | 0.0 |
| 2 | 2 | 1 | TRANSFER | India | 181.00 | C1305486145 | 181.00 | 0.00 | C553264065 | 0.0 | 0.00 | 2 | 0 | Current | 7/1/2018 | Morning | 1.0 |
| 3 | 3 | 1 | CASH_OUT | Australia | 181.00 | C840083671 | 181.00 | 0.00 | C38997010 | 21182.0 | 0.00 | 1 | 0 | Current | 6/1/2018 | Afternoon | 1.0 |
| 4 | 4 | 1 | PAYMENT | Australia | 11668.14 | C2048537720 | 41554.00 | 29885.86 | M1230701703 | 0.0 | 0.00 | 17 | 0 | Current | 6/1/2018 | Morning | 0.0 |
| 5 | 5 | 1 | PAYMENT | Australia | 7817.71 | C90045638 | 53860.00 | 46042.29 | M573487274 | 0.0 | 0.00 | 14 | 0 | Current | 8/1/2018 | Morning | 0.0 |
| 6 | 6 | 1 | PAYMENT | China | 7107.77 | C154988899 | 183195.00 | 176087.23 | M408069119 | 0.0 | 0.00 | 16 | 0 | NaN | 9/1/2018 | Night | 0.0 |
| 7 | 7 | 1 | PAYMENT | China | 7861.64 | C1912850431 | 176087.23 | 168225.59 | M633326333 | 0.0 | 0.00 | 19 | 0 | Current | 10/1/2018 | Morning | 0.0 |
| 8 | 8 | 1 | PAYMENT | China | 4024.36 | C1265012928 | 2671.00 | 0.00 | M1176932104 | 0.0 | 0.00 | 10 | 0 | Current | 11/1/2018 | Morning | 0.0 |
| 9 | 9 | 1 | DEBIT | China | 5337.77 | C712410124 | NaN | 36382.23 | C195600860 | 41898.0 | 40348.79 | 9 | 0 | Current | 12/1/2018 | Night | 0.0 |
| Unnamed: 0 | step | type | branch | amount | nameOrig | oldbalanceOrg | newbalanceOrig | nameDest | oldbalanceDest | newbalanceDest | unusuallogin | isFlaggedFraud | Acct type | Date of transaction | Time of day | isFraud | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10117 | 10117 | 7 | PAYMENT | Mexico | 8315.88 | C1728002047 | 87316.07 | 79000.19 | M1002544445 | 0.0 | 0.0 | 9 | 0 | Savings | 12/1/2018 | Night | 0.0 |
| 10118 | 10118 | 7 | PAYMENT | Mexico | 1507.32 | C1807064996 | 22377.00 | 20869.68 | M1439621082 | 0.0 | 0.0 | 7 | 0 | Current | 13/1/2018 | Morning | 0.0 |
| 10119 | 10119 | 7 | CASH_OUT | Republica Dominicana | 3387.85 | C1242647123 | 20869.68 | 17481.83 | C451433836 | 16148.0 | 0.0 | 14 | 0 | Savings | 16/1/2018 | Morning | 0.0 |
| 10120 | 10120 | 7 | PAYMENT | Mexico | 2711.69 | C2106465881 | 11278.00 | 8566.31 | M973207283 | 0.0 | 0.0 | 4 | 0 | Savings | 19/1/2018 | Night | 0.0 |
| 10121 | 10121 | 7 | CASH_OUT | El Salvador | 34311.33 | C429051494 | 8566.31 | 0.00 | C578294406 | 272678.0 | 1909674.3 | 2 | 0 | Savings | 25/1/2018 | Night | 0.0 |
| 10122 | 10122 | 7 | PAYMENT | Cuba | 337.50 | C1494306005 | 33107.00 | 32769.50 | M1424027000 | 0.0 | 0.0 | 7 | 0 | Current | 3/1/2018 | Afternoon | 0.0 |
| 10123 | 10123 | 7 | PAYMENT | Mexico | 5003.57 | C1633890169 | 32769.50 | 27765.93 | M1854745805 | 0.0 | 0.0 | 11 | 0 | Savings | 5/1/2018 | Morning | 0.0 |
| 10124 | 10124 | 7 | PAYMENT | Panama | 10424.89 | C1026138669 | 50780.00 | 40355.11 | M1852900317 | 0.0 | 0.0 | 6 | 0 | Savings | 7/1/2018 | Night | 0.0 |
| 10125 | 10125 | 7 | PAYMENT | Mexico | 2823.59 | C378659213 | 986.00 | 0.00 | M301812950 | 0.0 | 0.0 | 12 | 0 | Savings | 6/1/2018 | Night | 0.0 |
| 10126 | 10126 | 7 | PAYMENT | Cuba | 8126.71 | C1639296014 | 6423.00 | 0.00 | M129774606 | 0.0 | 0.0 | 11 | 0 | Current | 2/1/2018 | Afternoon | 0.0 |